Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | StoreSafeSettlementDocument(LE_HST_STR_SF) |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
SafeID (FK)(PK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | StoreSafeSettlementDocument(LE_HST_STR_SF) |
TenderOpenBalanceTotalAmount | The monetary amount of the opening balance of the STORE SAFE TENDER by safe settlement period. | MO_BLNC_OPN_TND | Money | decimal(16,5) | |
TenderLoanTotalAmount | The total monetary amount of the tender loans made FROM the SAFE in each safe settlement period. | MO_LON_TND_TOT | Money | decimal(16,5) | |
TotalTenderLoanCount | The total number of tender loans FROM the SAFE by safe settlement period. | QU_LON_TND_TOT | QuantityTransactionCount | decimal(7,0) | |
TenderPickupTotalAmount | The total monetary amount of the tender pickups loans made TO the SAFE by safe settlement period. | MO_PKP_TND_TOT | Money | decimal(16,5) | |
TotalTenderPickupCount | The total number of tender pickupsTO the SAFE by safe settlement period.. | QU_PKP_TND_TOT | QuantityTransactionCount | decimal(7,0) | |
TenderDepositTotalAmount | The total monetary amount of the tender deposits madeFROM the SAFE to the EXTERNAL DEPOSITORY by safe settlement period. | MO_DS_TND_TOT | Money | decimal(16,5) | |
TenderReceiptTotalAmount | The total monetary amount of the tender receipts madeTO the SAFE from the EXTERNAL DEPOSITORY by safe settlement period. | MO_RCV_TND_TOT | Money | decimal(16,5) | |
OverTenderDiscrepancyTotalAmount | The total monetary amount of tender overages recorded for the SAFE by safe settlement period. | MO_DSCP_TND_OVR_TOT | Money | decimal(16,5) | |
UnderTenderDiscrepancyTotalAmount | The total monetary amount of tender shortages recorded for the SAFE by safe settlement period. | MO_DSCP_TND_UND | Money | decimal(16,5) | |
PettyCashDisbursementTransactionTotalAmount | The total monetary amount of cash disbursements made from the SAFE by safe settlement period. | MO_DSB_PTY_CSH_TOT | Money | decimal(16,5) | |
TotalPettyCashDisbursementTransactionCount | The total number of cash disbursements made from the SAFE by safe settlement period. | QU_TRN_DSB_PTY_CSH | QuantityTransactionCount | decimal(7,0) | |
TotalTenderCountedAmount | The actual tender monetary value counted as part of the settlement process. | MO_TOT_TND__CNT_AMT | Money | decimal(16,5) | |